﻿db.Company.insert({
    "_id": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
    "CompanyName": "Cemex Finance LLC",
    "PeerGroupName": "Diversified Financial Services #",
    "PeerGroupID": NUUID("9c19a43d-a9f6-49f1-8452-061f32d0f6fc"),
    "ParentPeerGroupID": NUUID("0bcc0578-520b-4a72-93c6-a863c2d2321f"),
    "WorkingVersion": 1002,
});

db.Theme.insert({
    "_id": "E",
    "Name": "Environment",
    "SQLGUID": NUUID("00000000-0000-0000-0000-000000000000")
});

db.Topic.insert({
    "_id": "E.1",
    "Name": "Operations",
    "SQLGUID": NUUID("00000000-0000-0000-0000-000000000000")
});

db.Indicator.insert({
    "_id": "E.1.1",
    "Name": "Environmental Policy",
    "SQLGUID": NUUID("00000000-0000-0000-0000-000000000000")
});

db.MatrixCompany.insert({
    "_id": NUUID("00000000-0000-0000-0000-000000000000"),
    "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
    "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
});



db.ThemeRelativeWeights.insert({
    "_id":
        {
            "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
            "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
        },
    "Theme": "E",
    "WeightRelative": 6,
});
db.TopicRelativeWeights.insert({
    "_id":
        {
            "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
            "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
            "Theme": "E",
        },
    "Topic": "E.1",
    "WeightRelative": 6,
});
db.IndicatorWeights.insert({
    "_id":
        {
            "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
            "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
            "Theme": "E",
            "Topic": "E.1",
        },
    "Indicator": "E.1.1",
    "WeightRelative": 6,
});

db.MatrixCompanyThemeTopicIndicatorsWeightsRelative.insert({
    "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
    "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
    "Theme": "E",
    "ThemeWeightRelative": 6,
    "Topic": "E.1",
    "TopicWeightRelative": 6, // zero for disabled         
    "Indicator": "E.1.1",
    "IndicatorWeightRelative": 3   // zero for disabled 
});

db.MatrixCompanyThemeTopicIndicatorsWeights.insert({
    "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
    "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
    "Theme": "E",
    "ThemeWeight": 6,
    "Topic": "E.1",
    "TopicWeight": 6, // zero for disabled         
    "Indicator": "E.1.1",
    "IndicatorWeight": 3   // zero for disabled 
});


db.MatrixCompanyScore.insert({
    "_id": {
        "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
        "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
    },
    "score": "xx"    
});
db.MatrixCompanyThemeScore.insert({
    "_id": {
        "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
        "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
        "Theme":"E"
    },
    "score": "xx"
});

db.MatrixCompanyThemeTopicScore.insert({
    "_id": {
        "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
        "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
        "Theme": "E",
        "Topic": "E.1.1"
    },
    "score": "xx"
});

db.MatrixCompanyThemeTopicIndicatorScore.insert({
    "_id": {
        "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
        "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85"),
        "Theme": "E",
        "Topic": "E.1",
        "Indicator":"E.1.1"
    },
    "score": "xx"
});



db.MatrixCompanyThemeTopicIndicatorsWeights.insert({
    _id: {
        "MatrixID": NUUID("00000000-0000-0000-0000-000000000000"),
        "CompanyID": NUUID("85890483-16fd-4c17-ac7c-00004bcace85")
    },
    "Theme": "E",
    "ThemeWeight": 6,
    "Topic": "E.1",
    "TopicWeight": 6, // zero for disabled         
    "Indicator": "E.1.1",
    "IndicatorWeight": 3   // zero for disabled 
});



